package smartcommunityserver.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import smartcommunityserver.bean.OwnerWorkerPlaceBean;

import java.util.List;
@Mapper
public interface OwnerWorkPlaceMapper {
    @Select("SELECT\n" +
            "    owerWorkplace,\n" +
            "      sum(car_out_cnt+car_in_cnt) as owerWorkcount\n" +
            "FROM sca_doris_export.dws_car_behavior\n" +
            "GROUP BY owerWorkplace")
    List<OwnerWorkerPlaceBean> OwnerWorkPlaceMappe();
}
